﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AgnisdbDataSet" targetNamespace="http://tempuri.org/AgnisdbDataSet.xsd" xmlns:mstns="http://tempuri.org/AgnisdbDataSet.xsd" xmlns="http://tempuri.org/AgnisdbDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AgnisdbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AgnisdbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.AgnisDAL.Properties.Settings.GlobalReference.Default.AgnisdbConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AGNIS_FORMSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AGNIS_FORMSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.AgnisDAL.Properties.Settings.GlobalReference.Default.AGNIS_FORMSConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="form_element_errorTableAdapter" GeneratorDataComponentClassName="form_element_errorTableAdapter" Name="form_element_error" UserDataComponentName="form_element_errorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.form_element_error" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[form_element_error] WHERE (([FORM_ELEMENT_ERROR_ID] = @Original_FORM_ELEMENT_ERROR_ID) AND ((@IsNull_FORM_REVISION_ID = 1 AND [FORM_REVISION_ID] IS NULL) OR ([FORM_REVISION_ID] = @Original_FORM_REVISION_ID)) AND ((@IsNull_QUESTION_ID = 1 AND [QUESTION_ID] IS NULL) OR ([QUESTION_ID] = @Original_QUESTION_ID)) AND ((@IsNull_ERROR_TYPE = 1 AND [ERROR_TYPE] IS NULL) OR ([ERROR_TYPE] = @Original_ERROR_TYPE)) AND ((@IsNull_ERROR_MESSAGE = 1 AND [ERROR_MESSAGE] IS NULL) OR ([ERROR_MESSAGE] = @Original_ERROR_MESSAGE)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ERROR_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ERROR_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ERROR_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ERROR_MESSAGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ERROR_MESSAGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ERROR_MESSAGE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[form_element_error] ([FORM_ELEMENT_ERROR_ID], [FORM_REVISION_ID], [QUESTION_ID], [ERROR_TYPE], [ERROR_MESSAGE], [ERROR_RAW_DATA], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@FORM_ELEMENT_ERROR_ID, @FORM_REVISION_ID, @QUESTION_ID, @ERROR_TYPE, @ERROR_MESSAGE, @ERROR_RAW_DATA, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT FORM_ELEMENT_ERROR_ID, FORM_REVISION_ID, QUESTION_ID, ERROR_TYPE, ERROR_MESSAGE, ERROR_RAW_DATA, MODIFICATION_TIME, MODIFICATION_USER_ID FROM form_element_error WHERE (FORM_ELEMENT_ERROR_ID = @FORM_ELEMENT_ERROR_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ERROR_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ERROR_MESSAGE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ERROR_RAW_DATA" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="ERROR_RAW_DATA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT FORM_ELEMENT_ERROR_ID, FORM_REVISION_ID, QUESTION_ID, ERROR_TYPE, ERROR_MESSAGE, ERROR_RAW_DATA, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.form_element_error</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[form_element_error] SET [FORM_ELEMENT_ERROR_ID] = @FORM_ELEMENT_ERROR_ID, [FORM_REVISION_ID] = @FORM_REVISION_ID, [QUESTION_ID] = @QUESTION_ID, [ERROR_TYPE] = @ERROR_TYPE, [ERROR_MESSAGE] = @ERROR_MESSAGE, [ERROR_RAW_DATA] = @ERROR_RAW_DATA, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([FORM_ELEMENT_ERROR_ID] = @Original_FORM_ELEMENT_ERROR_ID) AND ((@IsNull_FORM_REVISION_ID = 1 AND [FORM_REVISION_ID] IS NULL) OR ([FORM_REVISION_ID] = @Original_FORM_REVISION_ID)) AND ((@IsNull_QUESTION_ID = 1 AND [QUESTION_ID] IS NULL) OR ([QUESTION_ID] = @Original_QUESTION_ID)) AND ((@IsNull_ERROR_TYPE = 1 AND [ERROR_TYPE] IS NULL) OR ([ERROR_TYPE] = @Original_ERROR_TYPE)) AND ((@IsNull_ERROR_MESSAGE = 1 AND [ERROR_MESSAGE] IS NULL) OR ([ERROR_MESSAGE] = @Original_ERROR_MESSAGE)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT FORM_ELEMENT_ERROR_ID, FORM_REVISION_ID, QUESTION_ID, ERROR_TYPE, ERROR_MESSAGE, ERROR_RAW_DATA, MODIFICATION_TIME, MODIFICATION_USER_ID FROM form_element_error WHERE (FORM_ELEMENT_ERROR_ID = @FORM_ELEMENT_ERROR_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ERROR_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ERROR_MESSAGE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ERROR_RAW_DATA" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="ERROR_RAW_DATA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ERROR_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ERROR_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ERROR_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ERROR_MESSAGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ERROR_MESSAGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ERROR_MESSAGE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FORM_ELEMENT_ERROR_ID" DataSetColumn="FORM_ELEMENT_ERROR_ID" />
              <Mapping SourceColumn="FORM_REVISION_ID" DataSetColumn="FORM_REVISION_ID" />
              <Mapping SourceColumn="QUESTION_ID" DataSetColumn="QUESTION_ID" />
              <Mapping SourceColumn="ERROR_TYPE" DataSetColumn="ERROR_TYPE" />
              <Mapping SourceColumn="ERROR_MESSAGE" DataSetColumn="ERROR_MESSAGE" />
              <Mapping SourceColumn="ERROR_RAW_DATA" DataSetColumn="ERROR_RAW_DATA" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="information_processTableAdapter" GeneratorDataComponentClassName="information_processTableAdapter" Name="information_process" UserDataComponentName="information_processTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.information_process" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[information_process] WHERE (([INFORMATION_PROCESS_ID] = @Original_INFORMATION_PROCESS_ID) AND ((@IsNull_UNIQUE_NAME = 1 AND [UNIQUE_NAME] IS NULL) OR ([UNIQUE_NAME] = @Original_UNIQUE_NAME)) AND ((@IsNull_DESCRIPTION = 1 AND [DESCRIPTION] IS NULL) OR ([DESCRIPTION] = @Original_DESCRIPTION)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UNIQUE_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESCRIPTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESCRIPTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DESCRIPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DESCRIPTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[information_process] ([INFORMATION_PROCESS_ID], [UNIQUE_NAME], [DESCRIPTION], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@INFORMATION_PROCESS_ID, @UNIQUE_NAME, @DESCRIPTION, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT INFORMATION_PROCESS_ID, UNIQUE_NAME, DESCRIPTION, MODIFICATION_TIME, MODIFICATION_USER_ID FROM information_process WHERE (INFORMATION_PROCESS_ID = @INFORMATION_PROCESS_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DESCRIPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DESCRIPTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT INFORMATION_PROCESS_ID, UNIQUE_NAME, DESCRIPTION, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.information_process</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[information_process] SET [INFORMATION_PROCESS_ID] = @INFORMATION_PROCESS_ID, [UNIQUE_NAME] = @UNIQUE_NAME, [DESCRIPTION] = @DESCRIPTION, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([INFORMATION_PROCESS_ID] = @Original_INFORMATION_PROCESS_ID) AND ((@IsNull_UNIQUE_NAME = 1 AND [UNIQUE_NAME] IS NULL) OR ([UNIQUE_NAME] = @Original_UNIQUE_NAME)) AND ((@IsNull_DESCRIPTION = 1 AND [DESCRIPTION] IS NULL) OR ([DESCRIPTION] = @Original_DESCRIPTION)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT INFORMATION_PROCESS_ID, UNIQUE_NAME, DESCRIPTION, MODIFICATION_TIME, MODIFICATION_USER_ID FROM information_process WHERE (INFORMATION_PROCESS_ID = @INFORMATION_PROCESS_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DESCRIPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DESCRIPTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UNIQUE_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DESCRIPTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DESCRIPTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DESCRIPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DESCRIPTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="INFORMATION_PROCESS_ID" DataSetColumn="INFORMATION_PROCESS_ID" />
              <Mapping SourceColumn="UNIQUE_NAME" DataSetColumn="UNIQUE_NAME" />
              <Mapping SourceColumn="DESCRIPTION" DataSetColumn="DESCRIPTION" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="institutionTableAdapter" GeneratorDataComponentClassName="institutionTableAdapter" Name="institution" UserDataComponentName="institutionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.institution" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[institution] WHERE (([INSTITUTION_ID] = @Original_INSTITUTION_ID) AND ((@IsNull_UNIQUE_NAME = 1 AND [UNIQUE_NAME] IS NULL) OR ([UNIQUE_NAME] = @Original_UNIQUE_NAME)) AND ((@IsNull_CURRENT_RETRIEVAL_SEQ_NUM = 1 AND [CURRENT_RETRIEVAL_SEQ_NUM] IS NULL) OR ([CURRENT_RETRIEVAL_SEQ_NUM] = @Original_CURRENT_RETRIEVAL_SEQ_NUM)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UNIQUE_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CURRENT_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CURRENT_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[institution] ([INSTITUTION_ID], [UNIQUE_NAME], [CURRENT_RETRIEVAL_SEQ_NUM], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@INSTITUTION_ID, @UNIQUE_NAME, @CURRENT_RETRIEVAL_SEQ_NUM, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT INSTITUTION_ID, UNIQUE_NAME, CURRENT_RETRIEVAL_SEQ_NUM, MODIFICATION_TIME, MODIFICATION_USER_ID FROM institution WHERE (INSTITUTION_ID = @INSTITUTION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CURRENT_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT INSTITUTION_ID, UNIQUE_NAME, CURRENT_RETRIEVAL_SEQ_NUM, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.institution</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[institution] SET [INSTITUTION_ID] = @INSTITUTION_ID, [UNIQUE_NAME] = @UNIQUE_NAME, [CURRENT_RETRIEVAL_SEQ_NUM] = @CURRENT_RETRIEVAL_SEQ_NUM, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([INSTITUTION_ID] = @Original_INSTITUTION_ID) AND ((@IsNull_UNIQUE_NAME = 1 AND [UNIQUE_NAME] IS NULL) OR ([UNIQUE_NAME] = @Original_UNIQUE_NAME)) AND ((@IsNull_CURRENT_RETRIEVAL_SEQ_NUM = 1 AND [CURRENT_RETRIEVAL_SEQ_NUM] IS NULL) OR ([CURRENT_RETRIEVAL_SEQ_NUM] = @Original_CURRENT_RETRIEVAL_SEQ_NUM)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT INSTITUTION_ID, UNIQUE_NAME, CURRENT_RETRIEVAL_SEQ_NUM, MODIFICATION_TIME, MODIFICATION_USER_ID FROM institution WHERE (INSTITUTION_ID = @INSTITUTION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CURRENT_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UNIQUE_NAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UNIQUE_NAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UNIQUE_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CURRENT_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CURRENT_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="INSTITUTION_ID" DataSetColumn="INSTITUTION_ID" />
              <Mapping SourceColumn="UNIQUE_NAME" DataSetColumn="UNIQUE_NAME" />
              <Mapping SourceColumn="CURRENT_RETRIEVAL_SEQ_NUM" DataSetColumn="CURRENT_RETRIEVAL_SEQ_NUM" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="moduleTableAdapter" GeneratorDataComponentClassName="moduleTableAdapter" Name="module" UserDataComponentName="moduleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.module" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[module] WHERE (([MODULE_ID] = @Original_MODULE_ID) AND ((@IsNull_FORM_REVISION_ID = 1 AND [FORM_REVISION_ID] IS NULL) OR ([FORM_REVISION_ID] = @Original_FORM_REVISION_ID)) AND ((@IsNull_PUBLIC_ID = 1 AND [PUBLIC_ID] IS NULL) OR ([PUBLIC_ID] = @Original_PUBLIC_ID)) AND ((@IsNull_VERSION = 1 AND [VERSION] IS NULL) OR ([VERSION] = @Original_VERSION)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_REPEAT_SEQUENCE_NUMBER = 1 AND [REPEAT_SEQUENCE_NUMBER] IS NULL) OR ([REPEAT_SEQUENCE_NUMBER] = @Original_REPEAT_SEQUENCE_NUMBER)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[module] ([MODULE_ID], [FORM_REVISION_ID], [PUBLIC_ID], [VERSION], [ALTERNATE_METADATA_TYPE], [ALTERNATE_METADATA_ID], [REPEAT_SEQUENCE_NUMBER], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@MODULE_ID, @FORM_REVISION_ID, @PUBLIC_ID, @VERSION, @ALTERNATE_METADATA_TYPE, @ALTERNATE_METADATA_ID, @REPEAT_SEQUENCE_NUMBER, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT MODULE_ID, FORM_REVISION_ID, PUBLIC_ID, VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, MODIFICATION_TIME, MODIFICATION_USER_ID FROM module WHERE (MODULE_ID = @MODULE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MODULE_ID, FORM_REVISION_ID, PUBLIC_ID, VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.module</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[module] SET [MODULE_ID] = @MODULE_ID, [FORM_REVISION_ID] = @FORM_REVISION_ID, [PUBLIC_ID] = @PUBLIC_ID, [VERSION] = @VERSION, [ALTERNATE_METADATA_TYPE] = @ALTERNATE_METADATA_TYPE, [ALTERNATE_METADATA_ID] = @ALTERNATE_METADATA_ID, [REPEAT_SEQUENCE_NUMBER] = @REPEAT_SEQUENCE_NUMBER, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([MODULE_ID] = @Original_MODULE_ID) AND ((@IsNull_FORM_REVISION_ID = 1 AND [FORM_REVISION_ID] IS NULL) OR ([FORM_REVISION_ID] = @Original_FORM_REVISION_ID)) AND ((@IsNull_PUBLIC_ID = 1 AND [PUBLIC_ID] IS NULL) OR ([PUBLIC_ID] = @Original_PUBLIC_ID)) AND ((@IsNull_VERSION = 1 AND [VERSION] IS NULL) OR ([VERSION] = @Original_VERSION)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_REPEAT_SEQUENCE_NUMBER = 1 AND [REPEAT_SEQUENCE_NUMBER] IS NULL) OR ([REPEAT_SEQUENCE_NUMBER] = @Original_REPEAT_SEQUENCE_NUMBER)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT MODULE_ID, FORM_REVISION_ID, PUBLIC_ID, VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, MODIFICATION_TIME, MODIFICATION_USER_ID FROM module WHERE (MODULE_ID = @MODULE_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MODULE_ID" DataSetColumn="MODULE_ID" />
              <Mapping SourceColumn="FORM_REVISION_ID" DataSetColumn="FORM_REVISION_ID" />
              <Mapping SourceColumn="PUBLIC_ID" DataSetColumn="PUBLIC_ID" />
              <Mapping SourceColumn="VERSION" DataSetColumn="VERSION" />
              <Mapping SourceColumn="ALTERNATE_METADATA_TYPE" DataSetColumn="ALTERNATE_METADATA_TYPE" />
              <Mapping SourceColumn="ALTERNATE_METADATA_ID" DataSetColumn="ALTERNATE_METADATA_ID" />
              <Mapping SourceColumn="REPEAT_SEQUENCE_NUMBER" DataSetColumn="REPEAT_SEQUENCE_NUMBER" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="processing_statusTableAdapter" GeneratorDataComponentClassName="processing_statusTableAdapter" Name="processing_status" UserDataComponentName="processing_statusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.processing_status" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[processing_status] WHERE (([PROCESSING_STATUS_ID] = @Original_PROCESSING_STATUS_ID) AND ((@IsNull_INFORMATION_PROCESS_ID = 1 AND [INFORMATION_PROCESS_ID] IS NULL) OR ([INFORMATION_PROCESS_ID] = @Original_INFORMATION_PROCESS_ID)) AND ((@IsNull_FORM_REVISION_ID = 1 AND [FORM_REVISION_ID] IS NULL) OR ([FORM_REVISION_ID] = @Original_FORM_REVISION_ID)) AND ((@IsNull_VALUE = 1 AND [VALUE] IS NULL) OR ([VALUE] = @Original_VALUE)) AND ((@IsNull_START_TIME = 1 AND [START_TIME] IS NULL) OR ([START_TIME] = @Original_START_TIME)) AND ((@IsNull_END_TIME = 1 AND [END_TIME] IS NULL) OR ([END_TIME] = @Original_END_TIME)) AND ((@IsNull_NOTE = 1 AND [NOTE] IS NULL) OR ([NOTE] = @Original_NOTE)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PROCESSING_STATUS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PROCESSING_STATUS_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_START_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="START_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="START_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_END_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="END_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_END_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="END_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NOTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NOTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NOTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NOTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[processing_status] ([PROCESSING_STATUS_ID], [INFORMATION_PROCESS_ID], [FORM_REVISION_ID], [VALUE], [START_TIME], [END_TIME], [NOTE], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@PROCESSING_STATUS_ID, @INFORMATION_PROCESS_ID, @FORM_REVISION_ID, @VALUE, @START_TIME, @END_TIME, @NOTE, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT PROCESSING_STATUS_ID, INFORMATION_PROCESS_ID, FORM_REVISION_ID, VALUE, START_TIME, END_TIME, NOTE, MODIFICATION_TIME, MODIFICATION_USER_ID FROM processing_status WHERE (PROCESSING_STATUS_ID = @PROCESSING_STATUS_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PROCESSING_STATUS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PROCESSING_STATUS_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="START_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@END_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="END_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NOTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NOTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PROCESSING_STATUS_ID, INFORMATION_PROCESS_ID, FORM_REVISION_ID, VALUE, START_TIME, END_TIME, NOTE, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.processing_status</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[processing_status] SET [PROCESSING_STATUS_ID] = @PROCESSING_STATUS_ID, [INFORMATION_PROCESS_ID] = @INFORMATION_PROCESS_ID, [FORM_REVISION_ID] = @FORM_REVISION_ID, [VALUE] = @VALUE, [START_TIME] = @START_TIME, [END_TIME] = @END_TIME, [NOTE] = @NOTE, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([PROCESSING_STATUS_ID] = @Original_PROCESSING_STATUS_ID) AND ((@IsNull_INFORMATION_PROCESS_ID = 1 AND [INFORMATION_PROCESS_ID] IS NULL) OR ([INFORMATION_PROCESS_ID] = @Original_INFORMATION_PROCESS_ID)) AND ((@IsNull_FORM_REVISION_ID = 1 AND [FORM_REVISION_ID] IS NULL) OR ([FORM_REVISION_ID] = @Original_FORM_REVISION_ID)) AND ((@IsNull_VALUE = 1 AND [VALUE] IS NULL) OR ([VALUE] = @Original_VALUE)) AND ((@IsNull_START_TIME = 1 AND [START_TIME] IS NULL) OR ([START_TIME] = @Original_START_TIME)) AND ((@IsNull_END_TIME = 1 AND [END_TIME] IS NULL) OR ([END_TIME] = @Original_END_TIME)) AND ((@IsNull_NOTE = 1 AND [NOTE] IS NULL) OR ([NOTE] = @Original_NOTE)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT PROCESSING_STATUS_ID, INFORMATION_PROCESS_ID, FORM_REVISION_ID, VALUE, START_TIME, END_TIME, NOTE, MODIFICATION_TIME, MODIFICATION_USER_ID FROM processing_status WHERE (PROCESSING_STATUS_ID = @PROCESSING_STATUS_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PROCESSING_STATUS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PROCESSING_STATUS_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="START_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@END_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="END_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NOTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NOTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PROCESSING_STATUS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PROCESSING_STATUS_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_INFORMATION_PROCESS_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INFORMATION_PROCESS_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_START_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="START_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="START_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_END_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="END_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_END_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="END_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NOTE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NOTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NOTE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NOTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PROCESSING_STATUS_ID" DataSetColumn="PROCESSING_STATUS_ID" />
              <Mapping SourceColumn="INFORMATION_PROCESS_ID" DataSetColumn="INFORMATION_PROCESS_ID" />
              <Mapping SourceColumn="FORM_REVISION_ID" DataSetColumn="FORM_REVISION_ID" />
              <Mapping SourceColumn="VALUE" DataSetColumn="VALUE" />
              <Mapping SourceColumn="START_TIME" DataSetColumn="START_TIME" />
              <Mapping SourceColumn="END_TIME" DataSetColumn="END_TIME" />
              <Mapping SourceColumn="NOTE" DataSetColumn="NOTE" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="questionTableAdapter" GeneratorDataComponentClassName="questionTableAdapter" Name="question" UserDataComponentName="questionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.question" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[question] WHERE (([QUESTION_ID] = @Original_QUESTION_ID) AND ((@IsNull_MODULE_ID = 1 AND [MODULE_ID] IS NULL) OR ([MODULE_ID] = @Original_MODULE_ID)) AND ((@IsNull_DATA_ELEMENT_PUBLIC_ID = 1 AND [DATA_ELEMENT_PUBLIC_ID] IS NULL) OR ([DATA_ELEMENT_PUBLIC_ID] = @Original_DATA_ELEMENT_PUBLIC_ID)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_REPEAT_SEQUENCE_NUMBER = 1 AND [REPEAT_SEQUENCE_NUMBER] IS NULL) OR ([REPEAT_SEQUENCE_NUMBER] = @Original_REPEAT_SEQUENCE_NUMBER)) AND ((@IsNull_VALUE = 1 AND [VALUE] IS NULL) OR ([VALUE] = @Original_VALUE)) AND ((@IsNull_ALTERNATE_VALUE = 1 AND [ALTERNATE_VALUE] IS NULL) OR ([ALTERNATE_VALUE] = @Original_ALTERNATE_VALUE)) AND ((@IsNull_ERROR_EXCEPTION = 1 AND [ERROR_EXCEPTION] IS NULL) OR ([ERROR_EXCEPTION] = @Original_ERROR_EXCEPTION)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ERROR_EXCEPTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ERROR_EXCEPTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ERROR_EXCEPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_EXCEPTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[question] ([QUESTION_ID], [MODULE_ID], [DATA_ELEMENT_PUBLIC_ID], [ALTERNATE_METADATA_TYPE], [ALTERNATE_METADATA_ID], [REPEAT_SEQUENCE_NUMBER], [VALUE], [ALTERNATE_VALUE], [ERROR_EXCEPTION], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@QUESTION_ID, @MODULE_ID, @DATA_ELEMENT_PUBLIC_ID, @ALTERNATE_METADATA_TYPE, @ALTERNATE_METADATA_ID, @REPEAT_SEQUENCE_NUMBER, @VALUE, @ALTERNATE_VALUE, @ERROR_EXCEPTION, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT QUESTION_ID, MODULE_ID, DATA_ELEMENT_PUBLIC_ID, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, VALUE, ALTERNATE_VALUE, ERROR_EXCEPTION, MODIFICATION_TIME, MODIFICATION_USER_ID FROM question WHERE (QUESTION_ID = @QUESTION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ERROR_EXCEPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_EXCEPTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT QUESTION_ID, MODULE_ID, DATA_ELEMENT_PUBLIC_ID, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, VALUE, ALTERNATE_VALUE, ERROR_EXCEPTION, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.question</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[question] SET [QUESTION_ID] = @QUESTION_ID, [MODULE_ID] = @MODULE_ID, [DATA_ELEMENT_PUBLIC_ID] = @DATA_ELEMENT_PUBLIC_ID, [ALTERNATE_METADATA_TYPE] = @ALTERNATE_METADATA_TYPE, [ALTERNATE_METADATA_ID] = @ALTERNATE_METADATA_ID, [REPEAT_SEQUENCE_NUMBER] = @REPEAT_SEQUENCE_NUMBER, [VALUE] = @VALUE, [ALTERNATE_VALUE] = @ALTERNATE_VALUE, [ERROR_EXCEPTION] = @ERROR_EXCEPTION, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([QUESTION_ID] = @Original_QUESTION_ID) AND ((@IsNull_MODULE_ID = 1 AND [MODULE_ID] IS NULL) OR ([MODULE_ID] = @Original_MODULE_ID)) AND ((@IsNull_DATA_ELEMENT_PUBLIC_ID = 1 AND [DATA_ELEMENT_PUBLIC_ID] IS NULL) OR ([DATA_ELEMENT_PUBLIC_ID] = @Original_DATA_ELEMENT_PUBLIC_ID)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_REPEAT_SEQUENCE_NUMBER = 1 AND [REPEAT_SEQUENCE_NUMBER] IS NULL) OR ([REPEAT_SEQUENCE_NUMBER] = @Original_REPEAT_SEQUENCE_NUMBER)) AND ((@IsNull_VALUE = 1 AND [VALUE] IS NULL) OR ([VALUE] = @Original_VALUE)) AND ((@IsNull_ALTERNATE_VALUE = 1 AND [ALTERNATE_VALUE] IS NULL) OR ([ALTERNATE_VALUE] = @Original_ALTERNATE_VALUE)) AND ((@IsNull_ERROR_EXCEPTION = 1 AND [ERROR_EXCEPTION] IS NULL) OR ([ERROR_EXCEPTION] = @Original_ERROR_EXCEPTION)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT QUESTION_ID, MODULE_ID, DATA_ELEMENT_PUBLIC_ID, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, VALUE, ALTERNATE_VALUE, ERROR_EXCEPTION, MODIFICATION_TIME, MODIFICATION_USER_ID FROM question WHERE (QUESTION_ID = @QUESTION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_VALUE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ERROR_EXCEPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_EXCEPTION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MODULE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_VALUE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_VALUE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_VALUE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_VALUE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ERROR_EXCEPTION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ERROR_EXCEPTION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ERROR_EXCEPTION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ERROR_EXCEPTION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="QUESTION_ID" DataSetColumn="QUESTION_ID" />
              <Mapping SourceColumn="MODULE_ID" DataSetColumn="MODULE_ID" />
              <Mapping SourceColumn="DATA_ELEMENT_PUBLIC_ID" DataSetColumn="DATA_ELEMENT_PUBLIC_ID" />
              <Mapping SourceColumn="ALTERNATE_METADATA_TYPE" DataSetColumn="ALTERNATE_METADATA_TYPE" />
              <Mapping SourceColumn="ALTERNATE_METADATA_ID" DataSetColumn="ALTERNATE_METADATA_ID" />
              <Mapping SourceColumn="REPEAT_SEQUENCE_NUMBER" DataSetColumn="REPEAT_SEQUENCE_NUMBER" />
              <Mapping SourceColumn="VALUE" DataSetColumn="VALUE" />
              <Mapping SourceColumn="ALTERNATE_VALUE" DataSetColumn="ALTERNATE_VALUE" />
              <Mapping SourceColumn="ERROR_EXCEPTION" DataSetColumn="ERROR_EXCEPTION" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="retrievalTableAdapter" GeneratorDataComponentClassName="retrievalTableAdapter" Name="retrieval" UserDataComponentName="retrievalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.retrieval" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[retrieval] WHERE (([RETRIEVAL_ID] = @Original_RETRIEVAL_ID) AND ([SUBSCRIBER_INSTITUTION_ID] = @Original_SUBSCRIBER_INSTITUTION_ID) AND ([RETRIEVAL_SEQ_NUM] = @Original_RETRIEVAL_SEQ_NUM) AND ((@IsNull_TRANSMITTED_TIME = 1 AND [TRANSMITTED_TIME] IS NULL) OR ([TRANSMITTED_TIME] = @Original_TRANSMITTED_TIME)) AND ((@IsNull_RETRIEVAL_ACKNOWLEDGED_STATUS = 1 AND [RETRIEVAL_ACKNOWLEDGED_STATUS] IS NULL) OR ([RETRIEVAL_ACKNOWLEDGED_STATUS] = @Original_RETRIEVAL_ACKNOWLEDGED_STATUS)) AND ((@IsNull_RETRIEVAL_ACKNOWLEDGED_TIME = 1 AND [RETRIEVAL_ACKNOWLEDGED_TIME] IS NULL) OR ([RETRIEVAL_ACKNOWLEDGED_TIME] = @Original_RETRIEVAL_ACKNOWLEDGED_TIME)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RETRIEVAL_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SUBSCRIBER_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SUBSCRIBER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRANSMITTED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANSMITTED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TRANSMITTED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TRANSMITTED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RETRIEVAL_ACKNOWLEDGED_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RETRIEVAL_ACKNOWLEDGED_STATUS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RETRIEVAL_ACKNOWLEDGED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RETRIEVAL_ACKNOWLEDGED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[retrieval] ([SUBSCRIBER_INSTITUTION_ID], [RETRIEVAL_SEQ_NUM], [TRANSMITTED_TIME], [RETRIEVAL_ACKNOWLEDGED_STATUS], [RETRIEVAL_ACKNOWLEDGED_TIME], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@SUBSCRIBER_INSTITUTION_ID, @RETRIEVAL_SEQ_NUM, @TRANSMITTED_TIME, @RETRIEVAL_ACKNOWLEDGED_STATUS, @RETRIEVAL_ACKNOWLEDGED_TIME, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT RETRIEVAL_ID, SUBSCRIBER_INSTITUTION_ID, RETRIEVAL_SEQ_NUM, TRANSMITTED_TIME, RETRIEVAL_ACKNOWLEDGED_STATUS, RETRIEVAL_ACKNOWLEDGED_TIME, MODIFICATION_TIME, MODIFICATION_USER_ID FROM retrieval WHERE (RETRIEVAL_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SUBSCRIBER_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SUBSCRIBER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TRANSMITTED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TRANSMITTED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RETRIEVAL_ACKNOWLEDGED_STATUS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RETRIEVAL_ACKNOWLEDGED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT RETRIEVAL_ID, SUBSCRIBER_INSTITUTION_ID, RETRIEVAL_SEQ_NUM, TRANSMITTED_TIME, RETRIEVAL_ACKNOWLEDGED_STATUS, RETRIEVAL_ACKNOWLEDGED_TIME, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.retrieval</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[retrieval] SET [SUBSCRIBER_INSTITUTION_ID] = @SUBSCRIBER_INSTITUTION_ID, [RETRIEVAL_SEQ_NUM] = @RETRIEVAL_SEQ_NUM, [TRANSMITTED_TIME] = @TRANSMITTED_TIME, [RETRIEVAL_ACKNOWLEDGED_STATUS] = @RETRIEVAL_ACKNOWLEDGED_STATUS, [RETRIEVAL_ACKNOWLEDGED_TIME] = @RETRIEVAL_ACKNOWLEDGED_TIME, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([RETRIEVAL_ID] = @Original_RETRIEVAL_ID) AND ([SUBSCRIBER_INSTITUTION_ID] = @Original_SUBSCRIBER_INSTITUTION_ID) AND ([RETRIEVAL_SEQ_NUM] = @Original_RETRIEVAL_SEQ_NUM) AND ((@IsNull_TRANSMITTED_TIME = 1 AND [TRANSMITTED_TIME] IS NULL) OR ([TRANSMITTED_TIME] = @Original_TRANSMITTED_TIME)) AND ((@IsNull_RETRIEVAL_ACKNOWLEDGED_STATUS = 1 AND [RETRIEVAL_ACKNOWLEDGED_STATUS] IS NULL) OR ([RETRIEVAL_ACKNOWLEDGED_STATUS] = @Original_RETRIEVAL_ACKNOWLEDGED_STATUS)) AND ((@IsNull_RETRIEVAL_ACKNOWLEDGED_TIME = 1 AND [RETRIEVAL_ACKNOWLEDGED_TIME] IS NULL) OR ([RETRIEVAL_ACKNOWLEDGED_TIME] = @Original_RETRIEVAL_ACKNOWLEDGED_TIME)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT RETRIEVAL_ID, SUBSCRIBER_INSTITUTION_ID, RETRIEVAL_SEQ_NUM, TRANSMITTED_TIME, RETRIEVAL_ACKNOWLEDGED_STATUS, RETRIEVAL_ACKNOWLEDGED_TIME, MODIFICATION_TIME, MODIFICATION_USER_ID FROM retrieval WHERE (RETRIEVAL_ID = @RETRIEVAL_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SUBSCRIBER_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SUBSCRIBER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TRANSMITTED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TRANSMITTED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RETRIEVAL_ACKNOWLEDGED_STATUS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RETRIEVAL_ACKNOWLEDGED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RETRIEVAL_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SUBSCRIBER_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SUBSCRIBER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RETRIEVAL_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRANSMITTED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANSMITTED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TRANSMITTED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TRANSMITTED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RETRIEVAL_ACKNOWLEDGED_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RETRIEVAL_ACKNOWLEDGED_STATUS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RETRIEVAL_ACKNOWLEDGED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RETRIEVAL_ACKNOWLEDGED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RETRIEVAL_ACKNOWLEDGED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="RETRIEVAL_ID" ColumnName="RETRIEVAL_ID" DataSourceName="Agnisdb.dbo.retrieval" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RETRIEVAL_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RETRIEVAL_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RETRIEVAL_ID" DataSetColumn="RETRIEVAL_ID" />
              <Mapping SourceColumn="SUBSCRIBER_INSTITUTION_ID" DataSetColumn="SUBSCRIBER_INSTITUTION_ID" />
              <Mapping SourceColumn="RETRIEVAL_SEQ_NUM" DataSetColumn="RETRIEVAL_SEQ_NUM" />
              <Mapping SourceColumn="TRANSMITTED_TIME" DataSetColumn="TRANSMITTED_TIME" />
              <Mapping SourceColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" DataSetColumn="RETRIEVAL_ACKNOWLEDGED_STATUS" />
              <Mapping SourceColumn="RETRIEVAL_ACKNOWLEDGED_TIME" DataSetColumn="RETRIEVAL_ACKNOWLEDGED_TIME" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="retrieval_form_revisionTableAdapter" GeneratorDataComponentClassName="retrieval_form_revisionTableAdapter" Name="retrieval_form_revision" UserDataComponentName="retrieval_form_revisionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.retrieval_form_revision" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[retrieval_form_revision] ([RETRIEVAL_ID], [FORM_REVISION_ID], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@RETRIEVAL_ID, @FORM_REVISION_ID, @MODIFICATION_TIME, @MODIFICATION_USER_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RETRIEVAL_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RETRIEVAL_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT RETRIEVAL_ID, FORM_REVISION_ID, MODIFICATION_TIME, MODIFICATION_USER_ID FROM dbo.retrieval_form_revision</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RETRIEVAL_ID" DataSetColumn="RETRIEVAL_ID" />
              <Mapping SourceColumn="FORM_REVISION_ID" DataSetColumn="FORM_REVISION_ID" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="test_questionTableAdapter" GeneratorDataComponentClassName="test_questionTableAdapter" Name="test_question" UserDataComponentName="test_questionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.test_question" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[test_question] WHERE (([TEST_QUESTION_ID] = @Original_TEST_QUESTION_ID) AND ((@IsNull_FORM_ELEMENT_ERROR_ID = 1 AND [FORM_ELEMENT_ERROR_ID] IS NULL) OR ([FORM_ELEMENT_ERROR_ID] = @Original_FORM_ELEMENT_ERROR_ID)) AND ((@IsNull_MODULE_PUBLIC_ID = 1 AND [MODULE_PUBLIC_ID] IS NULL) OR ([MODULE_PUBLIC_ID] = @Original_MODULE_PUBLIC_ID)) AND ((@IsNull_MODULE_VERSION = 1 AND [MODULE_VERSION] IS NULL) OR ([MODULE_VERSION] = @Original_MODULE_VERSION)) AND ((@IsNull_MODULE_ALTERNATE_METADATA_TYPE = 1 AND [MODULE_ALTERNATE_METADATA_TYPE] IS NULL) OR ([MODULE_ALTERNATE_METADATA_TYPE] = @Original_MODULE_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_MODULE_ALTERNATE_METADATA_ID = 1 AND [MODULE_ALTERNATE_METADATA_ID] IS NULL) OR ([MODULE_ALTERNATE_METADATA_ID] = @Original_MODULE_ALTERNATE_METADATA_ID)) AND ((@IsNull_REPEAT_SEQUENCE_NUMBER = 1 AND [REPEAT_SEQUENCE_NUMBER] IS NULL) OR ([REPEAT_SEQUENCE_NUMBER] = @Original_REPEAT_SEQUENCE_NUMBER)) AND ((@IsNull_DATA_ELEMENT_PUBLIC_ID = 1 AND [DATA_ELEMENT_PUBLIC_ID] IS NULL) OR ([DATA_ELEMENT_PUBLIC_ID] = @Original_DATA_ELEMENT_PUBLIC_ID)) AND ((@IsNull_DATA_ELEMENT_VERSION = 1 AND [DATA_ELEMENT_VERSION] IS NULL) OR ([DATA_ELEMENT_VERSION] = @Original_DATA_ELEMENT_VERSION)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_ODIFICATION_USER_ID = 1 AND [ODIFICATION_USER_ID] IS NULL) OR ([ODIFICATION_USER_ID] = @Original_ODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TEST_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TEST_QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MODULE_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MODULE_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MODULE_VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_ELEMENT_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DATA_ELEMENT_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DATA_ELEMENT_VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[test_question] ([TEST_QUESTION_ID], [FORM_ELEMENT_ERROR_ID], [MODULE_PUBLIC_ID], [MODULE_VERSION], [MODULE_ALTERNATE_METADATA_TYPE], [MODULE_ALTERNATE_METADATA_ID], [REPEAT_SEQUENCE_NUMBER], [DATA_ELEMENT_PUBLIC_ID], [DATA_ELEMENT_VERSION], [ALTERNATE_METADATA_TYPE], [ALTERNATE_METADATA_ID], [MODIFICATION_TIME], [ODIFICATION_USER_ID]) VALUES (@TEST_QUESTION_ID, @FORM_ELEMENT_ERROR_ID, @MODULE_PUBLIC_ID, @MODULE_VERSION, @MODULE_ALTERNATE_METADATA_TYPE, @MODULE_ALTERNATE_METADATA_ID, @REPEAT_SEQUENCE_NUMBER, @DATA_ELEMENT_PUBLIC_ID, @DATA_ELEMENT_VERSION, @ALTERNATE_METADATA_TYPE, @ALTERNATE_METADATA_ID, @MODIFICATION_TIME, @ODIFICATION_USER_ID);
SELECT TEST_QUESTION_ID, FORM_ELEMENT_ERROR_ID, MODULE_PUBLIC_ID, MODULE_VERSION, MODULE_ALTERNATE_METADATA_TYPE, MODULE_ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, DATA_ELEMENT_PUBLIC_ID, DATA_ELEMENT_VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, MODIFICATION_TIME, ODIFICATION_USER_ID FROM test_question WHERE (TEST_QUESTION_ID = @TEST_QUESTION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TEST_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TEST_QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MODULE_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MODULE_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MODULE_VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DATA_ELEMENT_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DATA_ELEMENT_VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TEST_QUESTION_ID, FORM_ELEMENT_ERROR_ID, MODULE_PUBLIC_ID, MODULE_VERSION, MODULE_ALTERNATE_METADATA_TYPE, MODULE_ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, DATA_ELEMENT_PUBLIC_ID, DATA_ELEMENT_VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, MODIFICATION_TIME, ODIFICATION_USER_ID FROM dbo.test_question</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[test_question] SET [TEST_QUESTION_ID] = @TEST_QUESTION_ID, [FORM_ELEMENT_ERROR_ID] = @FORM_ELEMENT_ERROR_ID, [MODULE_PUBLIC_ID] = @MODULE_PUBLIC_ID, [MODULE_VERSION] = @MODULE_VERSION, [MODULE_ALTERNATE_METADATA_TYPE] = @MODULE_ALTERNATE_METADATA_TYPE, [MODULE_ALTERNATE_METADATA_ID] = @MODULE_ALTERNATE_METADATA_ID, [REPEAT_SEQUENCE_NUMBER] = @REPEAT_SEQUENCE_NUMBER, [DATA_ELEMENT_PUBLIC_ID] = @DATA_ELEMENT_PUBLIC_ID, [DATA_ELEMENT_VERSION] = @DATA_ELEMENT_VERSION, [ALTERNATE_METADATA_TYPE] = @ALTERNATE_METADATA_TYPE, [ALTERNATE_METADATA_ID] = @ALTERNATE_METADATA_ID, [MODIFICATION_TIME] = @MODIFICATION_TIME, [ODIFICATION_USER_ID] = @ODIFICATION_USER_ID WHERE (([TEST_QUESTION_ID] = @Original_TEST_QUESTION_ID) AND ((@IsNull_FORM_ELEMENT_ERROR_ID = 1 AND [FORM_ELEMENT_ERROR_ID] IS NULL) OR ([FORM_ELEMENT_ERROR_ID] = @Original_FORM_ELEMENT_ERROR_ID)) AND ((@IsNull_MODULE_PUBLIC_ID = 1 AND [MODULE_PUBLIC_ID] IS NULL) OR ([MODULE_PUBLIC_ID] = @Original_MODULE_PUBLIC_ID)) AND ((@IsNull_MODULE_VERSION = 1 AND [MODULE_VERSION] IS NULL) OR ([MODULE_VERSION] = @Original_MODULE_VERSION)) AND ((@IsNull_MODULE_ALTERNATE_METADATA_TYPE = 1 AND [MODULE_ALTERNATE_METADATA_TYPE] IS NULL) OR ([MODULE_ALTERNATE_METADATA_TYPE] = @Original_MODULE_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_MODULE_ALTERNATE_METADATA_ID = 1 AND [MODULE_ALTERNATE_METADATA_ID] IS NULL) OR ([MODULE_ALTERNATE_METADATA_ID] = @Original_MODULE_ALTERNATE_METADATA_ID)) AND ((@IsNull_REPEAT_SEQUENCE_NUMBER = 1 AND [REPEAT_SEQUENCE_NUMBER] IS NULL) OR ([REPEAT_SEQUENCE_NUMBER] = @Original_REPEAT_SEQUENCE_NUMBER)) AND ((@IsNull_DATA_ELEMENT_PUBLIC_ID = 1 AND [DATA_ELEMENT_PUBLIC_ID] IS NULL) OR ([DATA_ELEMENT_PUBLIC_ID] = @Original_DATA_ELEMENT_PUBLIC_ID)) AND ((@IsNull_DATA_ELEMENT_VERSION = 1 AND [DATA_ELEMENT_VERSION] IS NULL) OR ([DATA_ELEMENT_VERSION] = @Original_DATA_ELEMENT_VERSION)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_ODIFICATION_USER_ID = 1 AND [ODIFICATION_USER_ID] IS NULL) OR ([ODIFICATION_USER_ID] = @Original_ODIFICATION_USER_ID)));
SELECT TEST_QUESTION_ID, FORM_ELEMENT_ERROR_ID, MODULE_PUBLIC_ID, MODULE_VERSION, MODULE_ALTERNATE_METADATA_TYPE, MODULE_ALTERNATE_METADATA_ID, REPEAT_SEQUENCE_NUMBER, DATA_ELEMENT_PUBLIC_ID, DATA_ELEMENT_VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, MODIFICATION_TIME, ODIFICATION_USER_ID FROM test_question WHERE (TEST_QUESTION_ID = @TEST_QUESTION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TEST_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TEST_QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MODULE_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MODULE_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MODULE_VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DATA_ELEMENT_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DATA_ELEMENT_VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TEST_QUESTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TEST_QUESTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_ELEMENT_ERROR_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_ELEMENT_ERROR_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MODULE_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MODULE_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MODULE_VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODULE_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MODULE_ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_REPEAT_SEQUENCE_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REPEAT_SEQUENCE_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DATA_ELEMENT_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_ELEMENT_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_ELEMENT_VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DATA_ELEMENT_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DATA_ELEMENT_VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ODIFICATION_USER_ID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TEST_QUESTION_ID" DataSetColumn="TEST_QUESTION_ID" />
              <Mapping SourceColumn="FORM_ELEMENT_ERROR_ID" DataSetColumn="FORM_ELEMENT_ERROR_ID" />
              <Mapping SourceColumn="MODULE_PUBLIC_ID" DataSetColumn="MODULE_PUBLIC_ID" />
              <Mapping SourceColumn="MODULE_VERSION" DataSetColumn="MODULE_VERSION" />
              <Mapping SourceColumn="MODULE_ALTERNATE_METADATA_TYPE" DataSetColumn="MODULE_ALTERNATE_METADATA_TYPE" />
              <Mapping SourceColumn="MODULE_ALTERNATE_METADATA_ID" DataSetColumn="MODULE_ALTERNATE_METADATA_ID" />
              <Mapping SourceColumn="REPEAT_SEQUENCE_NUMBER" DataSetColumn="REPEAT_SEQUENCE_NUMBER" />
              <Mapping SourceColumn="DATA_ELEMENT_PUBLIC_ID" DataSetColumn="DATA_ELEMENT_PUBLIC_ID" />
              <Mapping SourceColumn="DATA_ELEMENT_VERSION" DataSetColumn="DATA_ELEMENT_VERSION" />
              <Mapping SourceColumn="ALTERNATE_METADATA_TYPE" DataSetColumn="ALTERNATE_METADATA_TYPE" />
              <Mapping SourceColumn="ALTERNATE_METADATA_ID" DataSetColumn="ALTERNATE_METADATA_ID" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="ODIFICATION_USER_ID" DataSetColumn="ODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EBMTRecipientsTableAdapter" GeneratorDataComponentClassName="EBMTRecipientsTableAdapter" Name="EBMTRecipients" UserDataComponentName="EBMTRecipientsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AgnisdbConnectionString (Settings)" DbObjectName="Agnisdb.dbo.EBMTRecipients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [EBMTRecipients] WHERE (([ID] = @Original_ID) AND ([IDAA] = @Original_IDAA) AND ([Form_Id] = @Original_Form_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Form_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Form_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [EBMTRecipients] ([ID], [IDAA], [Form_Id]) VALUES (@ID, @IDAA, @Form_Id);
SELECT ID, IDAA, Form_Id FROM EBMTRecipients WHERE (ID = @ID) AND (IDAA = @IDAA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDAA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Form_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Form_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ID, IDAA, Form_Id
FROM         EBMTRecipients</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [EBMTRecipients] SET [ID] = @ID, [IDAA] = @IDAA, [Form_Id] = @Form_Id WHERE (([ID] = @Original_ID) AND ([IDAA] = @Original_IDAA) AND ([Form_Id] = @Original_Form_Id));
SELECT ID, IDAA, Form_Id FROM EBMTRecipients WHERE (ID = @ID) AND (IDAA = @IDAA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDAA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Form_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Form_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Form_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Form_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="IDAA" DataSetColumn="IDAA" />
              <Mapping SourceColumn="Form_Id" DataSetColumn="Form_Id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FORMTableAdapter" GeneratorDataComponentClassName="FORMTableAdapter" Name="FORM" UserDataComponentName="FORMTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AGNIS_FORMSConnectionString (Settings)" DbObjectName="AGNIS_FORMS.dbo.FORM" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [FORM] WHERE (([FORM_ID] = @Original_FORM_ID) AND ((@IsNull_PUBLISHER_INSTITUTION_ID = 1 AND [PUBLISHER_INSTITUTION_ID] IS NULL) OR ([PUBLISHER_INSTITUTION_ID] = @Original_PUBLISHER_INSTITUTION_ID)) AND ((@IsNull_INSTANCE_ID = 1 AND [INSTANCE_ID] IS NULL) OR ([INSTANCE_ID] = @Original_INSTANCE_ID)) AND ((@IsNull_ORIGINATOR_INSTITUTION_ID = 1 AND [ORIGINATOR_INSTITUTION_ID] IS NULL) OR ([ORIGINATOR_INSTITUTION_ID] = @Original_ORIGINATOR_INSTITUTION_ID)) AND ((@IsNull_PUBLIC_ID = 1 AND [PUBLIC_ID] IS NULL) OR ([PUBLIC_ID] = @Original_PUBLIC_ID)) AND ((@IsNull_VERSION = 1 AND [VERSION] IS NULL) OR ([VERSION] = @Original_VERSION)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_CURRENT_FORM_REVISION_SEQ_NUM = 1 AND [CURRENT_FORM_REVISION_SEQ_NUM] IS NULL) OR ([CURRENT_FORM_REVISION_SEQ_NUM] = @Original_CURRENT_FORM_REVISION_SEQ_NUM)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_FORM_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PUBLISHER_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLISHER_INSTITUTION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PUBLISHER_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLISHER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INSTANCE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INSTANCE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INSTANCE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INSTANCE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORIGINATOR_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORIGINATOR_INSTITUTION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ORIGINATOR_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ORIGINATOR_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PUBLIC_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CURRENT_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CURRENT_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [FORM] ([PUBLISHER_INSTITUTION_ID], [INSTANCE_ID], [ORIGINATOR_INSTITUTION_ID], [PUBLIC_ID], [VERSION], [ALTERNATE_METADATA_TYPE], [ALTERNATE_METADATA_ID], [CURRENT_FORM_REVISION_SEQ_NUM], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@PUBLISHER_INSTITUTION_ID, @INSTANCE_ID, @ORIGINATOR_INSTITUTION_ID, @PUBLIC_ID, @VERSION, @ALTERNATE_METADATA_TYPE, @ALTERNATE_METADATA_ID, @CURRENT_FORM_REVISION_SEQ_NUM, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT FORM_ID, PUBLISHER_INSTITUTION_ID, INSTANCE_ID, ORIGINATOR_INSTITUTION_ID, PUBLIC_ID, VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, CURRENT_FORM_REVISION_SEQ_NUM, MODIFICATION_TIME, MODIFICATION_USER_ID FROM FORM WHERE (FORM_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PUBLISHER_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLISHER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INSTANCE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INSTANCE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ORIGINATOR_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ORIGINATOR_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PUBLIC_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CURRENT_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     FORM_ID, PUBLISHER_INSTITUTION_ID, INSTANCE_ID, ORIGINATOR_INSTITUTION_ID, PUBLIC_ID, VERSION, ALTERNATE_METADATA_TYPE, 
                      ALTERNATE_METADATA_ID, CURRENT_FORM_REVISION_SEQ_NUM, MODIFICATION_TIME, MODIFICATION_USER_ID
FROM         FORM</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [FORM] SET [PUBLISHER_INSTITUTION_ID] = @PUBLISHER_INSTITUTION_ID, [INSTANCE_ID] = @INSTANCE_ID, [ORIGINATOR_INSTITUTION_ID] = @ORIGINATOR_INSTITUTION_ID, [PUBLIC_ID] = @PUBLIC_ID, [VERSION] = @VERSION, [ALTERNATE_METADATA_TYPE] = @ALTERNATE_METADATA_TYPE, [ALTERNATE_METADATA_ID] = @ALTERNATE_METADATA_ID, [CURRENT_FORM_REVISION_SEQ_NUM] = @CURRENT_FORM_REVISION_SEQ_NUM, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([FORM_ID] = @Original_FORM_ID) AND ((@IsNull_PUBLISHER_INSTITUTION_ID = 1 AND [PUBLISHER_INSTITUTION_ID] IS NULL) OR ([PUBLISHER_INSTITUTION_ID] = @Original_PUBLISHER_INSTITUTION_ID)) AND ((@IsNull_INSTANCE_ID = 1 AND [INSTANCE_ID] IS NULL) OR ([INSTANCE_ID] = @Original_INSTANCE_ID)) AND ((@IsNull_ORIGINATOR_INSTITUTION_ID = 1 AND [ORIGINATOR_INSTITUTION_ID] IS NULL) OR ([ORIGINATOR_INSTITUTION_ID] = @Original_ORIGINATOR_INSTITUTION_ID)) AND ((@IsNull_PUBLIC_ID = 1 AND [PUBLIC_ID] IS NULL) OR ([PUBLIC_ID] = @Original_PUBLIC_ID)) AND ((@IsNull_VERSION = 1 AND [VERSION] IS NULL) OR ([VERSION] = @Original_VERSION)) AND ((@IsNull_ALTERNATE_METADATA_TYPE = 1 AND [ALTERNATE_METADATA_TYPE] IS NULL) OR ([ALTERNATE_METADATA_TYPE] = @Original_ALTERNATE_METADATA_TYPE)) AND ((@IsNull_ALTERNATE_METADATA_ID = 1 AND [ALTERNATE_METADATA_ID] IS NULL) OR ([ALTERNATE_METADATA_ID] = @Original_ALTERNATE_METADATA_ID)) AND ((@IsNull_CURRENT_FORM_REVISION_SEQ_NUM = 1 AND [CURRENT_FORM_REVISION_SEQ_NUM] IS NULL) OR ([CURRENT_FORM_REVISION_SEQ_NUM] = @Original_CURRENT_FORM_REVISION_SEQ_NUM)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT FORM_ID, PUBLISHER_INSTITUTION_ID, INSTANCE_ID, ORIGINATOR_INSTITUTION_ID, PUBLIC_ID, VERSION, ALTERNATE_METADATA_TYPE, ALTERNATE_METADATA_ID, CURRENT_FORM_REVISION_SEQ_NUM, MODIFICATION_TIME, MODIFICATION_USER_ID FROM FORM WHERE (FORM_ID = @FORM_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PUBLISHER_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLISHER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INSTANCE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INSTANCE_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ORIGINATOR_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ORIGINATOR_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PUBLIC_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALTERNATE_METADATA_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CURRENT_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_FORM_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PUBLISHER_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLISHER_INSTITUTION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PUBLISHER_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLISHER_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INSTANCE_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INSTANCE_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INSTANCE_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INSTANCE_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORIGINATOR_INSTITUTION_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORIGINATOR_INSTITUTION_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ORIGINATOR_INSTITUTION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ORIGINATOR_INSTITUTION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PUBLIC_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PUBLIC_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PUBLIC_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VERSION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_VERSION" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="VERSION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALTERNATE_METADATA_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALTERNATE_METADATA_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALTERNATE_METADATA_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CURRENT_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CURRENT_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CURRENT_FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FORM_ID" ColumnName="FORM_ID" DataSourceName="AGNIS_FORMS.dbo.FORM" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@FORM_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FORM_ID" DataSetColumn="FORM_ID" />
              <Mapping SourceColumn="PUBLISHER_INSTITUTION_ID" DataSetColumn="PUBLISHER_INSTITUTION_ID" />
              <Mapping SourceColumn="INSTANCE_ID" DataSetColumn="INSTANCE_ID" />
              <Mapping SourceColumn="ORIGINATOR_INSTITUTION_ID" DataSetColumn="ORIGINATOR_INSTITUTION_ID" />
              <Mapping SourceColumn="PUBLIC_ID" DataSetColumn="PUBLIC_ID" />
              <Mapping SourceColumn="VERSION" DataSetColumn="VERSION" />
              <Mapping SourceColumn="ALTERNATE_METADATA_TYPE" DataSetColumn="ALTERNATE_METADATA_TYPE" />
              <Mapping SourceColumn="ALTERNATE_METADATA_ID" DataSetColumn="ALTERNATE_METADATA_ID" />
              <Mapping SourceColumn="CURRENT_FORM_REVISION_SEQ_NUM" DataSetColumn="CURRENT_FORM_REVISION_SEQ_NUM" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FORM_REVISIONTableAdapter" GeneratorDataComponentClassName="FORM_REVISIONTableAdapter" Name="FORM_REVISION" UserDataComponentName="FORM_REVISIONTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AGNIS_FORMSConnectionString (Settings)" DbObjectName="AGNIS_FORMS.dbo.FORM_REVISION" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [FORM_REVISION] WHERE (([FORM_REVISION_ID] = @Original_FORM_REVISION_ID) AND ([FORM_ID] = @Original_FORM_ID) AND ([FORM_REVISION_SEQ_NUM] = @Original_FORM_REVISION_SEQ_NUM) AND ((@IsNull_RECEIVED_TIME = 1 AND [RECEIVED_TIME] IS NULL) OR ([RECEIVED_TIME] = @Original_RECEIVED_TIME)) AND ((@IsNull_STATUS = 1 AND [STATUS] IS NULL) OR ([STATUS] = @Original_STATUS)) AND ((@IsNull_LOCK_STRING = 1 AND [LOCK_STRING] IS NULL) OR ([LOCK_STRING] = @Original_LOCK_STRING)) AND ((@IsNull_LOCK_OVERRIDE_FLAG = 1 AND [LOCK_OVERRIDE_FLAG] IS NULL) OR ([LOCK_OVERRIDE_FLAG] = @Original_LOCK_OVERRIDE_FLAG)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_FORM_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RECEIVED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RECEIVED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RECEIVED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RECEIVED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LOCK_STRING" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LOCK_STRING" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LOCK_STRING" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LOCK_STRING" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LOCK_OVERRIDE_FLAG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LOCK_OVERRIDE_FLAG" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_LOCK_OVERRIDE_FLAG" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="LOCK_OVERRIDE_FLAG" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [FORM_REVISION] ([FORM_REVISION_ID], [FORM_ID], [FORM_REVISION_SEQ_NUM], [RECEIVED_TIME], [STATUS], [LOCK_STRING], [LOCK_OVERRIDE_FLAG], [MODIFICATION_TIME], [MODIFICATION_USER_ID]) VALUES (@FORM_REVISION_ID, @FORM_ID, @FORM_REVISION_SEQ_NUM, @RECEIVED_TIME, @STATUS, @LOCK_STRING, @LOCK_OVERRIDE_FLAG, @MODIFICATION_TIME, @MODIFICATION_USER_ID);
SELECT FORM_REVISION_ID, FORM_ID, FORM_REVISION_SEQ_NUM, RECEIVED_TIME, STATUS, LOCK_STRING, LOCK_OVERRIDE_FLAG, MODIFICATION_TIME, MODIFICATION_USER_ID FROM FORM_REVISION WHERE (FORM_REVISION_ID = @FORM_REVISION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@FORM_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RECEIVED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RECEIVED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LOCK_STRING" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LOCK_STRING" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@LOCK_OVERRIDE_FLAG" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="LOCK_OVERRIDE_FLAG" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     FORM_REVISION_ID, FORM_ID, FORM_REVISION_SEQ_NUM, RECEIVED_TIME, STATUS, LOCK_STRING, LOCK_OVERRIDE_FLAG, 
                      MODIFICATION_TIME, MODIFICATION_USER_ID
FROM         FORM_REVISION</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [FORM_REVISION] SET [FORM_REVISION_ID] = @FORM_REVISION_ID, [FORM_ID] = @FORM_ID, [FORM_REVISION_SEQ_NUM] = @FORM_REVISION_SEQ_NUM, [RECEIVED_TIME] = @RECEIVED_TIME, [STATUS] = @STATUS, [LOCK_STRING] = @LOCK_STRING, [LOCK_OVERRIDE_FLAG] = @LOCK_OVERRIDE_FLAG, [MODIFICATION_TIME] = @MODIFICATION_TIME, [MODIFICATION_USER_ID] = @MODIFICATION_USER_ID WHERE (([FORM_REVISION_ID] = @Original_FORM_REVISION_ID) AND ([FORM_ID] = @Original_FORM_ID) AND ([FORM_REVISION_SEQ_NUM] = @Original_FORM_REVISION_SEQ_NUM) AND ((@IsNull_RECEIVED_TIME = 1 AND [RECEIVED_TIME] IS NULL) OR ([RECEIVED_TIME] = @Original_RECEIVED_TIME)) AND ((@IsNull_STATUS = 1 AND [STATUS] IS NULL) OR ([STATUS] = @Original_STATUS)) AND ((@IsNull_LOCK_STRING = 1 AND [LOCK_STRING] IS NULL) OR ([LOCK_STRING] = @Original_LOCK_STRING)) AND ((@IsNull_LOCK_OVERRIDE_FLAG = 1 AND [LOCK_OVERRIDE_FLAG] IS NULL) OR ([LOCK_OVERRIDE_FLAG] = @Original_LOCK_OVERRIDE_FLAG)) AND ((@IsNull_MODIFICATION_TIME = 1 AND [MODIFICATION_TIME] IS NULL) OR ([MODIFICATION_TIME] = @Original_MODIFICATION_TIME)) AND ((@IsNull_MODIFICATION_USER_ID = 1 AND [MODIFICATION_USER_ID] IS NULL) OR ([MODIFICATION_USER_ID] = @Original_MODIFICATION_USER_ID)));
SELECT FORM_REVISION_ID, FORM_ID, FORM_REVISION_SEQ_NUM, RECEIVED_TIME, STATUS, LOCK_STRING, LOCK_OVERRIDE_FLAG, MODIFICATION_TIME, MODIFICATION_USER_ID FROM FORM_REVISION WHERE (FORM_REVISION_ID = @FORM_REVISION_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@FORM_REVISION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@FORM_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RECEIVED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RECEIVED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LOCK_STRING" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LOCK_STRING" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@LOCK_OVERRIDE_FLAG" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="LOCK_OVERRIDE_FLAG" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_FORM_REVISION_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_FORM_ID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FORM_REVISION_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FORM_REVISION_SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RECEIVED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RECEIVED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RECEIVED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RECEIVED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LOCK_STRING" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LOCK_STRING" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LOCK_STRING" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LOCK_STRING" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LOCK_OVERRIDE_FLAG" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LOCK_OVERRIDE_FLAG" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_LOCK_OVERRIDE_FLAG" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="LOCK_OVERRIDE_FLAG" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_MODIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="MODIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MODIFICATION_USER_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MODIFICATION_USER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODIFICATION_USER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FORM_REVISION_ID" DataSetColumn="FORM_REVISION_ID" />
              <Mapping SourceColumn="FORM_ID" DataSetColumn="FORM_ID" />
              <Mapping SourceColumn="FORM_REVISION_SEQ_NUM" DataSetColumn="FORM_REVISION_SEQ_NUM" />
              <Mapping SourceColumn="RECEIVED_TIME" DataSetColumn="RECEIVED_TIME" />
              <Mapping SourceColumn="STATUS" DataSetColumn="STATUS" />
              <Mapping SourceColumn="LOCK_STRING" DataSetColumn="LOCK_STRING" />
              <Mapping SourceColumn="LOCK_OVERRIDE_FLAG" DataSetColumn="LOCK_OVERRIDE_FLAG" />
              <Mapping SourceColumn="MODIFICATION_TIME" DataSetColumn="MODIFICATION_TIME" />
              <Mapping SourceColumn="MODIFICATION_USER_ID" DataSetColumn="MODIFICATION_USER_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="AGNIS_FORMSConnectionString (Settings)" DbObjectName="AGNIS_FORMS.dbo.FORM_REVISION" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="FormRevisionIDExist" MethodsParameterType="CLR" Modifier="Public" Name="FormRevisionIDExist" QueryType="Scalar" ScalarCallRetval="System.Int64, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FormRevisionIDExist">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT     FORM_REVISION_ID
FROM         FORM_REVISION
WHERE     (FORM_REVISION_ID = @FormRevisionId)</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="false" AutogeneratedName="FormRevisionId" ColumnName="FORM_REVISION_ID" DataSourceName="AGNIS_FORMS.dbo.FORM_REVISION" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@FormRevisionId" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="FORM_REVISION_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="AGNIS_FORMSConnectionString (Settings)" DbObjectName="AGNIS_FORMS.dbo.FORM" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="FormIDExist" MethodsParameterType="CLR" Modifier="Public" Name="FormIDExist" QueryType="Scalar" ScalarCallRetval="System.Int64, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FormIDExist">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT     FORM_ID
FROM         FORM
WHERE     (FORM_ID = @FormId)</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="false" AutogeneratedName="FormId" ColumnName="FORM_ID" DataSourceName="AGNIS_FORMS.dbo.FORM" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@FormId" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="FORM_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="AGNIS_FORMSConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountFormRevision" MethodsParameterType="CLR" Modifier="Public" Name="CountFormRevision" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="CountFormRevision">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT     COUNT(FORM_REVISION_ID) AS Count
FROM         FORM_REVISION</CommandText>
                <Parameters />
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="AGNIS_FORMSConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountForm" MethodsParameterType="CLR" Modifier="Public" Name="CountForm" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="CountForm">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT     COUNT(FORM_ID) AS Count
FROM         FORM</CommandText>
                <Parameters />
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AgnisdbDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="AgnisdbDataSet" msprop:Generator_DataSetName="AgnisdbDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="form_element_error" msprop:Generator_UserTableName="form_element_error" msprop:Generator_RowDeletedName="form_element_errorRowDeleted" msprop:Generator_RowChangedName="form_element_errorRowChanged" msprop:Generator_RowClassName="form_element_errorRow" msprop:Generator_RowChangingName="form_element_errorRowChanging" msprop:Generator_RowEvArgName="form_element_errorRowChangeEvent" msprop:Generator_RowEvHandlerName="form_element_errorRowChangeEventHandler" msprop:Generator_TableClassName="form_element_errorDataTable" msprop:Generator_TableVarName="tableform_element_error" msprop:Generator_RowDeletingName="form_element_errorRowDeleting" msprop:Generator_TablePropName="form_element_error">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FORM_ELEMENT_ERROR_ID" msprop:Generator_UserColumnName="FORM_ELEMENT_ERROR_ID" msprop:Generator_ColumnPropNameInRow="FORM_ELEMENT_ERROR_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_ELEMENT_ERROR_ID" msprop:Generator_ColumnPropNameInTable="FORM_ELEMENT_ERROR_IDColumn" type="xs:int" />
              <xs:element name="FORM_REVISION_ID" msprop:Generator_UserColumnName="FORM_REVISION_ID" msprop:Generator_ColumnPropNameInRow="FORM_REVISION_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_REVISION_ID" msprop:Generator_ColumnPropNameInTable="FORM_REVISION_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="QUESTION_ID" msprop:Generator_UserColumnName="QUESTION_ID" msprop:Generator_ColumnPropNameInRow="QUESTION_ID" msprop:Generator_ColumnVarNameInTable="columnQUESTION_ID" msprop:Generator_ColumnPropNameInTable="QUESTION_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ERROR_TYPE" msprop:Generator_UserColumnName="ERROR_TYPE" msprop:Generator_ColumnPropNameInRow="ERROR_TYPE" msprop:Generator_ColumnVarNameInTable="columnERROR_TYPE" msprop:Generator_ColumnPropNameInTable="ERROR_TYPEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ERROR_MESSAGE" msprop:Generator_UserColumnName="ERROR_MESSAGE" msprop:Generator_ColumnPropNameInRow="ERROR_MESSAGE" msprop:Generator_ColumnVarNameInTable="columnERROR_MESSAGE" msprop:Generator_ColumnPropNameInTable="ERROR_MESSAGEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ERROR_RAW_DATA" msprop:Generator_UserColumnName="ERROR_RAW_DATA" msprop:Generator_ColumnPropNameInRow="ERROR_RAW_DATA" msprop:Generator_ColumnVarNameInTable="columnERROR_RAW_DATA" msprop:Generator_ColumnPropNameInTable="ERROR_RAW_DATAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="information_process" msprop:Generator_UserTableName="information_process" msprop:Generator_RowDeletedName="information_processRowDeleted" msprop:Generator_RowChangedName="information_processRowChanged" msprop:Generator_RowClassName="information_processRow" msprop:Generator_RowChangingName="information_processRowChanging" msprop:Generator_RowEvArgName="information_processRowChangeEvent" msprop:Generator_RowEvHandlerName="information_processRowChangeEventHandler" msprop:Generator_TableClassName="information_processDataTable" msprop:Generator_TableVarName="tableinformation_process" msprop:Generator_RowDeletingName="information_processRowDeleting" msprop:Generator_TablePropName="information_process">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="INFORMATION_PROCESS_ID" msprop:Generator_UserColumnName="INFORMATION_PROCESS_ID" msprop:Generator_ColumnPropNameInRow="INFORMATION_PROCESS_ID" msprop:Generator_ColumnVarNameInTable="columnINFORMATION_PROCESS_ID" msprop:Generator_ColumnPropNameInTable="INFORMATION_PROCESS_IDColumn" type="xs:int" />
              <xs:element name="UNIQUE_NAME" msprop:Generator_UserColumnName="UNIQUE_NAME" msprop:Generator_ColumnPropNameInRow="UNIQUE_NAME" msprop:Generator_ColumnVarNameInTable="columnUNIQUE_NAME" msprop:Generator_ColumnPropNameInTable="UNIQUE_NAMEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPTION" msprop:Generator_UserColumnName="DESCRIPTION" msprop:Generator_ColumnPropNameInRow="DESCRIPTION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPTION" msprop:Generator_ColumnPropNameInTable="DESCRIPTIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="institution" msprop:Generator_UserTableName="institution" msprop:Generator_RowDeletedName="institutionRowDeleted" msprop:Generator_RowChangedName="institutionRowChanged" msprop:Generator_RowClassName="institutionRow" msprop:Generator_RowChangingName="institutionRowChanging" msprop:Generator_RowEvArgName="institutionRowChangeEvent" msprop:Generator_RowEvHandlerName="institutionRowChangeEventHandler" msprop:Generator_TableClassName="institutionDataTable" msprop:Generator_TableVarName="tableinstitution" msprop:Generator_RowDeletingName="institutionRowDeleting" msprop:Generator_TablePropName="institution">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="INSTITUTION_ID" msprop:Generator_UserColumnName="INSTITUTION_ID" msprop:Generator_ColumnPropNameInRow="INSTITUTION_ID" msprop:Generator_ColumnVarNameInTable="columnINSTITUTION_ID" msprop:Generator_ColumnPropNameInTable="INSTITUTION_IDColumn" type="xs:int" />
              <xs:element name="UNIQUE_NAME" msprop:Generator_UserColumnName="UNIQUE_NAME" msprop:Generator_ColumnPropNameInRow="UNIQUE_NAME" msprop:Generator_ColumnVarNameInTable="columnUNIQUE_NAME" msprop:Generator_ColumnPropNameInTable="UNIQUE_NAMEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CURRENT_RETRIEVAL_SEQ_NUM" msprop:Generator_UserColumnName="CURRENT_RETRIEVAL_SEQ_NUM" msprop:Generator_ColumnPropNameInRow="CURRENT_RETRIEVAL_SEQ_NUM" msprop:Generator_ColumnVarNameInTable="columnCURRENT_RETRIEVAL_SEQ_NUM" msprop:Generator_ColumnPropNameInTable="CURRENT_RETRIEVAL_SEQ_NUMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="module" msprop:Generator_UserTableName="module" msprop:Generator_RowDeletedName="moduleRowDeleted" msprop:Generator_RowChangedName="moduleRowChanged" msprop:Generator_RowClassName="moduleRow" msprop:Generator_RowChangingName="moduleRowChanging" msprop:Generator_RowEvArgName="moduleRowChangeEvent" msprop:Generator_RowEvHandlerName="moduleRowChangeEventHandler" msprop:Generator_TableClassName="moduleDataTable" msprop:Generator_TableVarName="tablemodule" msprop:Generator_RowDeletingName="moduleRowDeleting" msprop:Generator_TablePropName="module">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MODULE_ID" msprop:Generator_UserColumnName="MODULE_ID" msprop:Generator_ColumnPropNameInRow="MODULE_ID" msprop:Generator_ColumnVarNameInTable="columnMODULE_ID" msprop:Generator_ColumnPropNameInTable="MODULE_IDColumn" type="xs:int" />
              <xs:element name="FORM_REVISION_ID" msprop:Generator_UserColumnName="FORM_REVISION_ID" msprop:Generator_ColumnPropNameInRow="FORM_REVISION_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_REVISION_ID" msprop:Generator_ColumnPropNameInTable="FORM_REVISION_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="PUBLIC_ID" msprop:Generator_UserColumnName="PUBLIC_ID" msprop:Generator_ColumnPropNameInRow="PUBLIC_ID" msprop:Generator_ColumnVarNameInTable="columnPUBLIC_ID" msprop:Generator_ColumnPropNameInTable="PUBLIC_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="VERSION" msprop:Generator_UserColumnName="VERSION" msprop:Generator_ColumnPropNameInRow="VERSION" msprop:Generator_ColumnVarNameInTable="columnVERSION" msprop:Generator_ColumnPropNameInTable="VERSIONColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ALTERNATE_METADATA_TYPE" msprop:Generator_UserColumnName="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_TYPEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALTERNATE_METADATA_ID" msprop:Generator_UserColumnName="ALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_ID" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REPEAT_SEQUENCE_NUMBER" msprop:Generator_UserColumnName="REPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnPropNameInRow="REPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnVarNameInTable="columnREPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnPropNameInTable="REPEAT_SEQUENCE_NUMBERColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="processing_status" msprop:Generator_UserTableName="processing_status" msprop:Generator_RowDeletedName="processing_statusRowDeleted" msprop:Generator_RowChangedName="processing_statusRowChanged" msprop:Generator_RowClassName="processing_statusRow" msprop:Generator_RowChangingName="processing_statusRowChanging" msprop:Generator_RowEvArgName="processing_statusRowChangeEvent" msprop:Generator_RowEvHandlerName="processing_statusRowChangeEventHandler" msprop:Generator_TableClassName="processing_statusDataTable" msprop:Generator_TableVarName="tableprocessing_status" msprop:Generator_RowDeletingName="processing_statusRowDeleting" msprop:Generator_TablePropName="processing_status">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PROCESSING_STATUS_ID" msprop:Generator_UserColumnName="PROCESSING_STATUS_ID" msprop:Generator_ColumnPropNameInRow="PROCESSING_STATUS_ID" msprop:Generator_ColumnVarNameInTable="columnPROCESSING_STATUS_ID" msprop:Generator_ColumnPropNameInTable="PROCESSING_STATUS_IDColumn" type="xs:int" />
              <xs:element name="INFORMATION_PROCESS_ID" msprop:Generator_UserColumnName="INFORMATION_PROCESS_ID" msprop:Generator_ColumnPropNameInRow="INFORMATION_PROCESS_ID" msprop:Generator_ColumnVarNameInTable="columnINFORMATION_PROCESS_ID" msprop:Generator_ColumnPropNameInTable="INFORMATION_PROCESS_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FORM_REVISION_ID" msprop:Generator_UserColumnName="FORM_REVISION_ID" msprop:Generator_ColumnPropNameInRow="FORM_REVISION_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_REVISION_ID" msprop:Generator_ColumnPropNameInTable="FORM_REVISION_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="VALUE" msprop:Generator_UserColumnName="VALUE" msprop:Generator_ColumnPropNameInRow="VALUE" msprop:Generator_ColumnVarNameInTable="columnVALUE" msprop:Generator_ColumnPropNameInTable="VALUEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="START_TIME" msprop:Generator_UserColumnName="START_TIME" msprop:Generator_ColumnPropNameInRow="START_TIME" msprop:Generator_ColumnVarNameInTable="columnSTART_TIME" msprop:Generator_ColumnPropNameInTable="START_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="END_TIME" msprop:Generator_UserColumnName="END_TIME" msprop:Generator_ColumnPropNameInRow="END_TIME" msprop:Generator_ColumnVarNameInTable="columnEND_TIME" msprop:Generator_ColumnPropNameInTable="END_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NOTE" msprop:Generator_UserColumnName="NOTE" msprop:Generator_ColumnPropNameInRow="NOTE" msprop:Generator_ColumnVarNameInTable="columnNOTE" msprop:Generator_ColumnPropNameInTable="NOTEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="question" msprop:Generator_UserTableName="question" msprop:Generator_RowDeletedName="questionRowDeleted" msprop:Generator_RowChangedName="questionRowChanged" msprop:Generator_RowClassName="questionRow" msprop:Generator_RowChangingName="questionRowChanging" msprop:Generator_RowEvArgName="questionRowChangeEvent" msprop:Generator_RowEvHandlerName="questionRowChangeEventHandler" msprop:Generator_TableClassName="questionDataTable" msprop:Generator_TableVarName="tablequestion" msprop:Generator_RowDeletingName="questionRowDeleting" msprop:Generator_TablePropName="question">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="QUESTION_ID" msprop:Generator_UserColumnName="QUESTION_ID" msprop:Generator_ColumnPropNameInRow="QUESTION_ID" msprop:Generator_ColumnVarNameInTable="columnQUESTION_ID" msprop:Generator_ColumnPropNameInTable="QUESTION_IDColumn" type="xs:int" />
              <xs:element name="MODULE_ID" msprop:Generator_UserColumnName="MODULE_ID" msprop:Generator_ColumnPropNameInRow="MODULE_ID" msprop:Generator_ColumnVarNameInTable="columnMODULE_ID" msprop:Generator_ColumnPropNameInTable="MODULE_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DATA_ELEMENT_PUBLIC_ID" msprop:Generator_UserColumnName="DATA_ELEMENT_PUBLIC_ID" msprop:Generator_ColumnPropNameInRow="DATA_ELEMENT_PUBLIC_ID" msprop:Generator_ColumnVarNameInTable="columnDATA_ELEMENT_PUBLIC_ID" msprop:Generator_ColumnPropNameInTable="DATA_ELEMENT_PUBLIC_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ALTERNATE_METADATA_TYPE" msprop:Generator_UserColumnName="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_TYPEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALTERNATE_METADATA_ID" msprop:Generator_UserColumnName="ALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_ID" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REPEAT_SEQUENCE_NUMBER" msprop:Generator_UserColumnName="REPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnPropNameInRow="REPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnVarNameInTable="columnREPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnPropNameInTable="REPEAT_SEQUENCE_NUMBERColumn" type="xs:int" minOccurs="0" />
              <xs:element name="VALUE" msprop:Generator_UserColumnName="VALUE" msprop:Generator_ColumnPropNameInRow="VALUE" msprop:Generator_ColumnVarNameInTable="columnVALUE" msprop:Generator_ColumnPropNameInTable="VALUEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALTERNATE_VALUE" msprop:Generator_UserColumnName="ALTERNATE_VALUE" msprop:Generator_ColumnPropNameInRow="ALTERNATE_VALUE" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_VALUE" msprop:Generator_ColumnPropNameInTable="ALTERNATE_VALUEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ERROR_EXCEPTION" msprop:Generator_UserColumnName="ERROR_EXCEPTION" msprop:Generator_ColumnPropNameInRow="ERROR_EXCEPTION" msprop:Generator_ColumnVarNameInTable="columnERROR_EXCEPTION" msprop:Generator_ColumnPropNameInTable="ERROR_EXCEPTIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="retrieval" msprop:Generator_UserTableName="retrieval" msprop:Generator_RowDeletedName="retrievalRowDeleted" msprop:Generator_RowChangedName="retrievalRowChanged" msprop:Generator_RowClassName="retrievalRow" msprop:Generator_RowChangingName="retrievalRowChanging" msprop:Generator_RowEvArgName="retrievalRowChangeEvent" msprop:Generator_RowEvHandlerName="retrievalRowChangeEventHandler" msprop:Generator_TableClassName="retrievalDataTable" msprop:Generator_TableVarName="tableretrieval" msprop:Generator_RowDeletingName="retrievalRowDeleting" msprop:Generator_TablePropName="retrieval">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RETRIEVAL_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="RETRIEVAL_ID" msprop:Generator_ColumnPropNameInRow="RETRIEVAL_ID" msprop:Generator_ColumnVarNameInTable="columnRETRIEVAL_ID" msprop:Generator_ColumnPropNameInTable="RETRIEVAL_IDColumn" type="xs:int" />
              <xs:element name="SUBSCRIBER_INSTITUTION_ID" msprop:Generator_UserColumnName="SUBSCRIBER_INSTITUTION_ID" msprop:Generator_ColumnPropNameInRow="SUBSCRIBER_INSTITUTION_ID" msprop:Generator_ColumnVarNameInTable="columnSUBSCRIBER_INSTITUTION_ID" msprop:Generator_ColumnPropNameInTable="SUBSCRIBER_INSTITUTION_IDColumn" type="xs:int" />
              <xs:element name="RETRIEVAL_SEQ_NUM" msprop:Generator_UserColumnName="RETRIEVAL_SEQ_NUM" msprop:Generator_ColumnPropNameInRow="RETRIEVAL_SEQ_NUM" msprop:Generator_ColumnVarNameInTable="columnRETRIEVAL_SEQ_NUM" msprop:Generator_ColumnPropNameInTable="RETRIEVAL_SEQ_NUMColumn" type="xs:int" />
              <xs:element name="TRANSMITTED_TIME" msprop:Generator_UserColumnName="TRANSMITTED_TIME" msprop:Generator_ColumnPropNameInRow="TRANSMITTED_TIME" msprop:Generator_ColumnVarNameInTable="columnTRANSMITTED_TIME" msprop:Generator_ColumnPropNameInTable="TRANSMITTED_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RETRIEVAL_ACKNOWLEDGED_STATUS" msprop:Generator_UserColumnName="RETRIEVAL_ACKNOWLEDGED_STATUS" msprop:Generator_ColumnPropNameInRow="RETRIEVAL_ACKNOWLEDGED_STATUS" msprop:Generator_ColumnVarNameInTable="columnRETRIEVAL_ACKNOWLEDGED_STATUS" msprop:Generator_ColumnPropNameInTable="RETRIEVAL_ACKNOWLEDGED_STATUSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RETRIEVAL_ACKNOWLEDGED_TIME" msprop:Generator_UserColumnName="RETRIEVAL_ACKNOWLEDGED_TIME" msprop:Generator_ColumnPropNameInRow="RETRIEVAL_ACKNOWLEDGED_TIME" msprop:Generator_ColumnVarNameInTable="columnRETRIEVAL_ACKNOWLEDGED_TIME" msprop:Generator_ColumnPropNameInTable="RETRIEVAL_ACKNOWLEDGED_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="retrieval_form_revision" msprop:Generator_UserTableName="retrieval_form_revision" msprop:Generator_RowDeletedName="retrieval_form_revisionRowDeleted" msprop:Generator_RowChangedName="retrieval_form_revisionRowChanged" msprop:Generator_RowClassName="retrieval_form_revisionRow" msprop:Generator_RowChangingName="retrieval_form_revisionRowChanging" msprop:Generator_RowEvArgName="retrieval_form_revisionRowChangeEvent" msprop:Generator_RowEvHandlerName="retrieval_form_revisionRowChangeEventHandler" msprop:Generator_TableClassName="retrieval_form_revisionDataTable" msprop:Generator_TableVarName="tableretrieval_form_revision" msprop:Generator_RowDeletingName="retrieval_form_revisionRowDeleting" msprop:Generator_TablePropName="retrieval_form_revision">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RETRIEVAL_ID" msprop:Generator_UserColumnName="RETRIEVAL_ID" msprop:Generator_ColumnPropNameInRow="RETRIEVAL_ID" msprop:Generator_ColumnVarNameInTable="columnRETRIEVAL_ID" msprop:Generator_ColumnPropNameInTable="RETRIEVAL_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FORM_REVISION_ID" msprop:Generator_UserColumnName="FORM_REVISION_ID" msprop:Generator_ColumnPropNameInRow="FORM_REVISION_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_REVISION_ID" msprop:Generator_ColumnPropNameInTable="FORM_REVISION_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="test_question" msprop:Generator_UserTableName="test_question" msprop:Generator_RowDeletedName="test_questionRowDeleted" msprop:Generator_RowChangedName="test_questionRowChanged" msprop:Generator_RowClassName="test_questionRow" msprop:Generator_RowChangingName="test_questionRowChanging" msprop:Generator_RowEvArgName="test_questionRowChangeEvent" msprop:Generator_RowEvHandlerName="test_questionRowChangeEventHandler" msprop:Generator_TableClassName="test_questionDataTable" msprop:Generator_TableVarName="tabletest_question" msprop:Generator_RowDeletingName="test_questionRowDeleting" msprop:Generator_TablePropName="test_question">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TEST_QUESTION_ID" msprop:Generator_UserColumnName="TEST_QUESTION_ID" msprop:Generator_ColumnPropNameInRow="TEST_QUESTION_ID" msprop:Generator_ColumnVarNameInTable="columnTEST_QUESTION_ID" msprop:Generator_ColumnPropNameInTable="TEST_QUESTION_IDColumn" type="xs:int" />
              <xs:element name="FORM_ELEMENT_ERROR_ID" msprop:Generator_UserColumnName="FORM_ELEMENT_ERROR_ID" msprop:Generator_ColumnPropNameInRow="FORM_ELEMENT_ERROR_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_ELEMENT_ERROR_ID" msprop:Generator_ColumnPropNameInTable="FORM_ELEMENT_ERROR_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MODULE_PUBLIC_ID" msprop:Generator_UserColumnName="MODULE_PUBLIC_ID" msprop:Generator_ColumnPropNameInRow="MODULE_PUBLIC_ID" msprop:Generator_ColumnVarNameInTable="columnMODULE_PUBLIC_ID" msprop:Generator_ColumnPropNameInTable="MODULE_PUBLIC_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MODULE_VERSION" msprop:Generator_UserColumnName="MODULE_VERSION" msprop:Generator_ColumnPropNameInRow="MODULE_VERSION" msprop:Generator_ColumnVarNameInTable="columnMODULE_VERSION" msprop:Generator_ColumnPropNameInTable="MODULE_VERSIONColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="MODULE_ALTERNATE_METADATA_TYPE" msprop:Generator_UserColumnName="MODULE_ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInRow="MODULE_ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnVarNameInTable="columnMODULE_ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInTable="MODULE_ALTERNATE_METADATA_TYPEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODULE_ALTERNATE_METADATA_ID" msprop:Generator_UserColumnName="MODULE_ALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInRow="MODULE_ALTERNATE_METADATA_ID" msprop:Generator_ColumnVarNameInTable="columnMODULE_ALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInTable="MODULE_ALTERNATE_METADATA_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REPEAT_SEQUENCE_NUMBER" msprop:Generator_UserColumnName="REPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnPropNameInRow="REPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnVarNameInTable="columnREPEAT_SEQUENCE_NUMBER" msprop:Generator_ColumnPropNameInTable="REPEAT_SEQUENCE_NUMBERColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DATA_ELEMENT_PUBLIC_ID" msprop:Generator_UserColumnName="DATA_ELEMENT_PUBLIC_ID" msprop:Generator_ColumnPropNameInRow="DATA_ELEMENT_PUBLIC_ID" msprop:Generator_ColumnVarNameInTable="columnDATA_ELEMENT_PUBLIC_ID" msprop:Generator_ColumnPropNameInTable="DATA_ELEMENT_PUBLIC_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DATA_ELEMENT_VERSION" msprop:Generator_UserColumnName="DATA_ELEMENT_VERSION" msprop:Generator_ColumnPropNameInRow="DATA_ELEMENT_VERSION" msprop:Generator_ColumnVarNameInTable="columnDATA_ELEMENT_VERSION" msprop:Generator_ColumnPropNameInTable="DATA_ELEMENT_VERSIONColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ALTERNATE_METADATA_TYPE" msprop:Generator_UserColumnName="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_TYPEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALTERNATE_METADATA_ID" msprop:Generator_UserColumnName="ALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_ID" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ODIFICATION_USER_ID" msprop:Generator_UserColumnName="ODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="ODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="ODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EBMTRecipients" msprop:Generator_UserTableName="EBMTRecipients" msprop:Generator_RowDeletedName="EBMTRecipientsRowDeleted" msprop:Generator_RowChangedName="EBMTRecipientsRowChanged" msprop:Generator_RowClassName="EBMTRecipientsRow" msprop:Generator_RowChangingName="EBMTRecipientsRowChanging" msprop:Generator_RowEvArgName="EBMTRecipientsRowChangeEvent" msprop:Generator_RowEvHandlerName="EBMTRecipientsRowChangeEventHandler" msprop:Generator_TableClassName="EBMTRecipientsDataTable" msprop:Generator_TableVarName="tableEBMTRecipients" msprop:Generator_RowDeletingName="EBMTRecipientsRowDeleting" msprop:Generator_TablePropName="EBMTRecipients">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="IDAA" msprop:Generator_UserColumnName="IDAA" msprop:Generator_ColumnVarNameInTable="columnIDAA" msprop:Generator_ColumnPropNameInRow="IDAA" msprop:Generator_ColumnPropNameInTable="IDAAColumn" type="xs:int" />
              <xs:element name="Form_Id" msprop:Generator_UserColumnName="Form_Id" msprop:Generator_ColumnVarNameInTable="columnForm_Id" msprop:Generator_ColumnPropNameInRow="Form_Id" msprop:Generator_ColumnPropNameInTable="Form_IdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FORM" msprop:Generator_UserTableName="FORM" msprop:Generator_RowDeletedName="FORMRowDeleted" msprop:Generator_TableClassName="FORMDataTable" msprop:Generator_RowChangedName="FORMRowChanged" msprop:Generator_RowClassName="FORMRow" msprop:Generator_RowChangingName="FORMRowChanging" msprop:Generator_RowEvArgName="FORMRowChangeEvent" msprop:Generator_RowEvHandlerName="FORMRowChangeEventHandler" msprop:Generator_TablePropName="FORM" msprop:Generator_TableVarName="tableFORM" msprop:Generator_RowDeletingName="FORMRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FORM_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="FORM_ID" msprop:Generator_ColumnPropNameInRow="FORM_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_ID" msprop:Generator_ColumnPropNameInTable="FORM_IDColumn" type="xs:long" />
              <xs:element name="PUBLISHER_INSTITUTION_ID" msprop:Generator_UserColumnName="PUBLISHER_INSTITUTION_ID" msprop:Generator_ColumnPropNameInRow="PUBLISHER_INSTITUTION_ID" msprop:Generator_ColumnVarNameInTable="columnPUBLISHER_INSTITUTION_ID" msprop:Generator_ColumnPropNameInTable="PUBLISHER_INSTITUTION_IDColumn" type="xs:long" minOccurs="0" />
              <xs:element name="INSTANCE_ID" msprop:Generator_UserColumnName="INSTANCE_ID" msprop:Generator_ColumnPropNameInRow="INSTANCE_ID" msprop:Generator_ColumnVarNameInTable="columnINSTANCE_ID" msprop:Generator_ColumnPropNameInTable="INSTANCE_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORIGINATOR_INSTITUTION_ID" msprop:Generator_UserColumnName="ORIGINATOR_INSTITUTION_ID" msprop:Generator_ColumnPropNameInRow="ORIGINATOR_INSTITUTION_ID" msprop:Generator_ColumnVarNameInTable="columnORIGINATOR_INSTITUTION_ID" msprop:Generator_ColumnPropNameInTable="ORIGINATOR_INSTITUTION_IDColumn" type="xs:long" minOccurs="0" />
              <xs:element name="PUBLIC_ID" msprop:Generator_UserColumnName="PUBLIC_ID" msprop:Generator_ColumnPropNameInRow="PUBLIC_ID" msprop:Generator_ColumnVarNameInTable="columnPUBLIC_ID" msprop:Generator_ColumnPropNameInTable="PUBLIC_IDColumn" type="xs:long" minOccurs="0" />
              <xs:element name="VERSION" msprop:Generator_UserColumnName="VERSION" msprop:Generator_ColumnPropNameInRow="VERSION" msprop:Generator_ColumnVarNameInTable="columnVERSION" msprop:Generator_ColumnPropNameInTable="VERSIONColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ALTERNATE_METADATA_TYPE" msprop:Generator_UserColumnName="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_TYPE" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_TYPE" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_TYPEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALTERNATE_METADATA_ID" msprop:Generator_UserColumnName="ALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInRow="ALTERNATE_METADATA_ID" msprop:Generator_ColumnVarNameInTable="columnALTERNATE_METADATA_ID" msprop:Generator_ColumnPropNameInTable="ALTERNATE_METADATA_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CURRENT_FORM_REVISION_SEQ_NUM" msprop:Generator_UserColumnName="CURRENT_FORM_REVISION_SEQ_NUM" msprop:Generator_ColumnPropNameInRow="CURRENT_FORM_REVISION_SEQ_NUM" msprop:Generator_ColumnVarNameInTable="columnCURRENT_FORM_REVISION_SEQ_NUM" msprop:Generator_ColumnPropNameInTable="CURRENT_FORM_REVISION_SEQ_NUMColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FORM_REVISION" msprop:Generator_UserTableName="FORM_REVISION" msprop:Generator_RowDeletedName="FORM_REVISIONRowDeleted" msprop:Generator_TableClassName="FORM_REVISIONDataTable" msprop:Generator_RowChangedName="FORM_REVISIONRowChanged" msprop:Generator_RowClassName="FORM_REVISIONRow" msprop:Generator_RowChangingName="FORM_REVISIONRowChanging" msprop:Generator_RowEvArgName="FORM_REVISIONRowChangeEvent" msprop:Generator_RowEvHandlerName="FORM_REVISIONRowChangeEventHandler" msprop:Generator_TablePropName="FORM_REVISION" msprop:Generator_TableVarName="tableFORM_REVISION" msprop:Generator_RowDeletingName="FORM_REVISIONRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FORM_REVISION_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="FORM_REVISION_ID" msprop:Generator_ColumnPropNameInRow="FORM_REVISION_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_REVISION_ID" msprop:Generator_ColumnPropNameInTable="FORM_REVISION_IDColumn" type="xs:long" />
              <xs:element name="FORM_ID" msprop:Generator_UserColumnName="FORM_ID" msprop:Generator_ColumnPropNameInRow="FORM_ID" msprop:Generator_ColumnVarNameInTable="columnFORM_ID" msprop:Generator_ColumnPropNameInTable="FORM_IDColumn" type="xs:long" />
              <xs:element name="FORM_REVISION_SEQ_NUM" msprop:Generator_UserColumnName="FORM_REVISION_SEQ_NUM" msprop:Generator_ColumnPropNameInRow="FORM_REVISION_SEQ_NUM" msprop:Generator_ColumnVarNameInTable="columnFORM_REVISION_SEQ_NUM" msprop:Generator_ColumnPropNameInTable="FORM_REVISION_SEQ_NUMColumn" type="xs:int" />
              <xs:element name="RECEIVED_TIME" msprop:Generator_UserColumnName="RECEIVED_TIME" msprop:Generator_ColumnPropNameInRow="RECEIVED_TIME" msprop:Generator_ColumnVarNameInTable="columnRECEIVED_TIME" msprop:Generator_ColumnPropNameInTable="RECEIVED_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="STATUS" msprop:Generator_UserColumnName="STATUS" msprop:Generator_ColumnPropNameInRow="STATUS" msprop:Generator_ColumnVarNameInTable="columnSTATUS" msprop:Generator_ColumnPropNameInTable="STATUSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LOCK_STRING" msprop:Generator_UserColumnName="LOCK_STRING" msprop:Generator_ColumnPropNameInRow="LOCK_STRING" msprop:Generator_ColumnVarNameInTable="columnLOCK_STRING" msprop:Generator_ColumnPropNameInTable="LOCK_STRINGColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LOCK_OVERRIDE_FLAG" msprop:Generator_UserColumnName="LOCK_OVERRIDE_FLAG" msprop:Generator_ColumnPropNameInRow="LOCK_OVERRIDE_FLAG" msprop:Generator_ColumnVarNameInTable="columnLOCK_OVERRIDE_FLAG" msprop:Generator_ColumnPropNameInTable="LOCK_OVERRIDE_FLAGColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="MODIFICATION_TIME" msprop:Generator_UserColumnName="MODIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="MODIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="MODIFICATION_TIMEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MODIFICATION_USER_ID" msprop:Generator_UserColumnName="MODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInRow="MODIFICATION_USER_ID" msprop:Generator_ColumnVarNameInTable="columnMODIFICATION_USER_ID" msprop:Generator_ColumnPropNameInTable="MODIFICATION_USER_IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:form_element_error" />
      <xs:field xpath="mstns:FORM_ELEMENT_ERROR_ID" />
    </xs:unique>
    <xs:unique name="information_process_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:information_process" />
      <xs:field xpath="mstns:INFORMATION_PROCESS_ID" />
    </xs:unique>
    <xs:unique name="institution_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:institution" />
      <xs:field xpath="mstns:INSTITUTION_ID" />
    </xs:unique>
    <xs:unique name="module_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:module" />
      <xs:field xpath="mstns:MODULE_ID" />
    </xs:unique>
    <xs:unique name="processing_status_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:processing_status" />
      <xs:field xpath="mstns:PROCESSING_STATUS_ID" />
    </xs:unique>
    <xs:unique name="question_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:question" />
      <xs:field xpath="mstns:QUESTION_ID" />
    </xs:unique>
    <xs:unique name="retrieval_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:retrieval" />
      <xs:field xpath="mstns:RETRIEVAL_ID" />
    </xs:unique>
    <xs:unique name="retrieval_form_revision_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:retrieval_form_revision" />
      <xs:field xpath="mstns:RETRIEVAL_ID" />
      <xs:field xpath="mstns:FORM_REVISION_ID" />
    </xs:unique>
    <xs:unique name="test_question_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:test_question" />
      <xs:field xpath="mstns:TEST_QUESTION_ID" />
    </xs:unique>
    <xs:unique name="EBMTRecipients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EBMTRecipients" />
      <xs:field xpath="mstns:ID" />
      <xs:field xpath="mstns:IDAA" />
    </xs:unique>
    <xs:unique name="FORM_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FORM" />
      <xs:field xpath="mstns:FORM_ID" />
    </xs:unique>
    <xs:unique name="FORM_REVISION_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FORM_REVISION" />
      <xs:field xpath="mstns:FORM_REVISION_ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_form_element_error_question" msdata:parent="question" msdata:child="form_element_error" msdata:parentkey="QUESTION_ID" msdata:childkey="QUESTION_ID" msprop:Generator_UserRelationName="FK_form_element_error_question" msprop:Generator_RelationVarName="relationFK_form_element_error_question" msprop:Generator_UserChildTable="form_element_error" msprop:Generator_UserParentTable="question" msprop:Generator_ParentPropName="questionRow" msprop:Generator_ChildPropName="Getform_element_errorRows" />
      <msdata:Relationship name="FK_processing_status_information_process" msdata:parent="information_process" msdata:child="processing_status" msdata:parentkey="INFORMATION_PROCESS_ID" msdata:childkey="INFORMATION_PROCESS_ID" msprop:Generator_UserRelationName="FK_processing_status_information_process" msprop:Generator_RelationVarName="relationFK_processing_status_information_process" msprop:Generator_UserChildTable="processing_status" msprop:Generator_UserParentTable="information_process" msprop:Generator_ParentPropName="information_processRow" msprop:Generator_ChildPropName="Getprocessing_statusRows" />
      <msdata:Relationship name="FK_question_module" msdata:parent="module" msdata:child="question" msdata:parentkey="MODULE_ID" msdata:childkey="MODULE_ID" msprop:Generator_UserRelationName="FK_question_module" msprop:Generator_RelationVarName="relationFK_question_module" msprop:Generator_UserChildTable="question" msprop:Generator_UserParentTable="module" msprop:Generator_ParentPropName="moduleRow" msprop:Generator_ChildPropName="GetquestionRows" />
      <msdata:Relationship name="fk_retrieval_subscriber" msdata:parent="institution" msdata:child="retrieval" msdata:parentkey="INSTITUTION_ID" msdata:childkey="SUBSCRIBER_INSTITUTION_ID" msprop:Generator_UserRelationName="fk_retrieval_subscriber" msprop:Generator_RelationVarName="relationfk_retrieval_subscriber" msprop:Generator_UserChildTable="retrieval" msprop:Generator_UserParentTable="institution" msprop:Generator_ParentPropName="institutionRow" msprop:Generator_ChildPropName="GetretrievalRows" />
      <msdata:Relationship name="FK_retrieval_form_revision_retrieval" msdata:parent="retrieval" msdata:child="retrieval_form_revision" msdata:parentkey="RETRIEVAL_ID" msdata:childkey="RETRIEVAL_ID" msprop:Generator_UserRelationName="FK_retrieval_form_revision_retrieval" msprop:Generator_RelationVarName="relationFK_retrieval_form_revision_retrieval" msprop:Generator_UserChildTable="retrieval_form_revision" msprop:Generator_UserParentTable="retrieval" msprop:Generator_ParentPropName="retrievalRow" msprop:Generator_ChildPropName="Getretrieval_form_revisionRows" />
      <msdata:Relationship name="fk_test_question_error" msdata:parent="form_element_error" msdata:child="test_question" msdata:parentkey="FORM_ELEMENT_ERROR_ID" msdata:childkey="FORM_ELEMENT_ERROR_ID" msprop:Generator_UserRelationName="fk_test_question_error" msprop:Generator_RelationVarName="relationfk_test_question_error" msprop:Generator_UserChildTable="test_question" msprop:Generator_UserParentTable="form_element_error" msprop:Generator_ParentPropName="form_element_errorRow" msprop:Generator_ChildPropName="Gettest_questionRows" />
      <msdata:Relationship name="FORM_REVISION_FORM" msdata:parent="FORM_REVISION" msdata:child="FORM" msdata:parentkey="FORM_ID" msdata:childkey="FORM_ID" msprop:Generator_UserRelationName="FORM_REVISION_FORM" msprop:Generator_RelationVarName="relationFORM_REVISION_FORM" msprop:Generator_UserChildTable="FORM" msprop:Generator_UserParentTable="FORM_REVISION" msprop:Generator_ParentPropName="FORM_REVISIONRow" msprop:Generator_ChildPropName="GetFORMRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>